USE [influenza]
GO

/****** Object:  Table [dbo].[dat_generales_del]    Script Date: 01/08/2010 17:58:33 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dat_generales_del]') AND type in (N'U'))
DROP TABLE [dbo].[dat_generales_del]
GO

USE [influenza]
GO

/****** Object:  Table [dbo].[dat_generales_del]    Script Date: 01/08/2010 17:58:33 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[dat_generales_del](
	[id_principal] [bigint] NULL,
	[id_sector] [smallint] NULL,
	[id_unidad] [bigint] NULL,
	[cNombre] [varchar](100) NULL,
	[cPaterno] [varchar](70) NULL,
	[cMaterno] [varchar](70) NULL,
	[nTP] [smallint] NULL,
	[nAfiliado] [smallint] NULL,
	[cAfiliacion] [varchar](150) NULL,
	[nSexo] [smallint] NULL,
	[nEmbarazada] [smallint] NULL,
	[nMesesE] [smallint] NULL,
	[nAnio] [smallint] NULL,
	[nMeses] [varchar](2) NULL,
	[nDias] [varchar](2) NULL,
	[nNacionalidad] [smallint] NULL,
	[nPais_Nacimiento] [smallint] NULL,
	[nEntidad_Nacimiento] [smallint] NULL,
	[curp] [varchar](18) NULL,
	[nEntidad] [smallint] NULL,
	[nMunicipio] [smallint] NULL,
	[nLocalidad] [int] NULL,
	[calle] [varchar](100) NULL,
	[calle1] [varchar](100) NULL,
	[calle2] [varchar](100) NULL,
	[cp] [varchar](5) NULL,
	[cCalle_numero] [varchar](20) NULL,
	[cColonia] [varchar](100) NULL,
	[telefono] [varchar](30) NULL,
	[nOcupacion] [smallint] NULL,
	[cInstitucion] [varchar](500) NULL,
	[cGuarderia] [varchar](500) NULL,
	[nIndigena] [smallint] NULL,
	[nLenguaIndigena] [smallint] NULL,
	[fCreacion] [datetime] NULL,
	[fModificacion] [datetime] NULL,
	[id_usuario] [int] NULL,
	[nStatus] [smallint] NULL,
	[nActivo] [smallint] NULL,
	[nOrigenDatos] [smallint] NULL,
	[cId_Origen] [varchar](15) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


